/** Copyright (c) 2012, peter.ducai@gmail.com
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*     * Redistributions of source code must retain the above copyright
*       notice, this list of conditions and the following disclaimer.
*     * Redistributions in binary form must reproduce the above copyright
*       notice, this list of conditions and the following disclaimer in the
*       documentation and/or other materials provided with the distribution.
*     * Neither the name of the Peter Ducai nor the
*       names of its contributors may be used to endorse or promote products
*       derived from this software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL PETER "daemonna" DUCAI BE LIABLE FOR ANY
* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

package com.daemonna.fluentlee_core.database;

import com.daemonna.fluentlee_core.objects.connector;
import com.daemonna.fluentlee_core.pools.schedule_pool;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

/*
 * @author peter 'daemonna' ducai @author peter.ducai@gmail.com @author
 * http://code.google.com/p/fluentlee/
 */
public abstract class db_postgres implements db_manager {

    public enum status {

        INNACTIVE, ACTIVE, CLOSED
    }
    Statement stmt;
    Connection conn;
    ResultSet rset;
    public status db_status = status.INNACTIVE;

    @Override
    public void init_db(connector con) {

        if (db_status != status.ACTIVE) {
            db_status = status.ACTIVE;
            try {
                Class.forName("org.postgresql.Driver");
                // Setup the connection with the DB
                conn = DriverManager.getConnection(con.url, con.user, con.password);
            } catch (SQLException ex) {
                Logger.getLogger(db_postgres.class.getName()).log(Level.SEVERE, null, ex);
            } catch (ClassNotFoundException ex) {
                Logger.getLogger(db_postgres.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }

    @Override
    public void execute_sql(String some_sql) {
        try {
            conn.setAutoCommit(false);
            stmt = conn.createStatement();
            stmt.execute(some_sql);
            stmt.close();
        } catch (SQLException ex) {
            Logger.getLogger(db_postgres.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    @Override
    public ResultSet execute_sql_query(String some_sql, int sched_index, int x, int v) {
        try {
            conn.setAutoCommit(true);
            stmt = conn.createStatement();
            schedule_pool.getInstance().scheds[sched_index].suites[x].jobs[v].sql_resultset = stmt.executeQuery(some_sql);
            while (schedule_pool.getInstance().scheds[sched_index].suites[x].jobs[v].sql_resultset.next()) {
                //System.out.println(rset.getInt(1));
            }
        } catch (SQLException ex) {
            Logger.getLogger(db_postgres.class.getName()).log(Level.SEVERE, null, ex);
        }
        return rset;
    }

    @Override
    public void execute_file(String path_to_sql_file) {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public void close_db() {
        throw new UnsupportedOperationException("Not supported yet.");
    }
}
